package com.kittlen.managementSystem.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.kittlen.managementSystem.entity.MySqlLimit;
import com.kittlen.managementSystem.entity.Student;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 学员表 Mapper 接口
 * </p>
 *
 * @author kittlen
 * @since 2021-01-26
 */
public interface StudentMapper extends BaseMapper<Student> {
    @Select("select * from `t_student` ${ew.customSqlSegment} LIMIT #{mySqlLimit.offset},#{mySqlLimit.rows}")
    List<Student> selects(@Param(Constants.WRAPPER) Wrapper wrapper, @Param("mySqlLimit") MySqlLimit mySqlLimit);
    //用户导入
    int batchInsert(List<Student> list);
}
